package com.java.dao;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.HashMap;

import com.java.util.DaoUtils;

public class Com0101lp03Pop02Dao extends CommonDao{
	public ArrayList execute(HashMap requestMap,Connection con) {

		ArrayList return_list = new ArrayList();
		
		ArrayList list1 = null;
		ArrayList list2 = null;
		ArrayList list3 = null;
		try {
			String queryStr = "call com_com0101p03_p02List1(?)";

			String param[] = new String[1];
			param[0] = (String) requestMap.get("uni_id");

			list1 = DaoUtils.select(con, queryStr, param);
			return_list.add(list1);
			
			queryStr = "call com_com0101p03_p02List2(?)";

			param = new String[1];
			param[0] = (String) requestMap.get("uni_id");

			list2 = DaoUtils.select(con, queryStr, param);
			return_list.add(list2);
			
			queryStr = "call com_com0101p03_p02List3(?)";

			param = new String[1];
			param[0] = (String) requestMap.get("uni_id");

			list3 = DaoUtils.select(con, queryStr, param);
			return_list.add(list3);

		} catch (Exception ee) {
			ee.printStackTrace();
		}finally {
			try{
				if (con!=null) con.setAutoCommit(true);
				if (con!=null) con.close();
			}catch(Exception ee){}
		}
		return return_list;
	}
	

}
